SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409974 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409974 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426110,1002310,822070,673490,894353,611170,844013,939483,390411,409604,467296,304609,823357,279375,91756,586053,689143,608519,294574,604502,483840,994541,887944,670176,555008,64646,431615,297169,80021,634108,750231,444294,151637,693589,498860,38223,368567,9604,557933,155487,822685,278878,170987,539060,477785,665661,262741,453617,774686,370903,819476,747432,1045778,429172,794730,459891,562162,352270,177878,175109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]