SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405953 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405953 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436654,992503,1008155,852510,833067,899835,799935,511272,418337,389189,332469,723424,644149,1048065,684085,199877,917930,151413,303202,859610,124551,272795,99878,971510,446063,168577,223673,639009,538055,549488,881818,799249,71278,577116,486937,606244,373354,640495,648363,97630,886870,607837,477473,746508,866892,175301,967215,854175,592099,945263,815837,562662,18092,909610,505138,28131,163781,314408,189319,1033512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003257s ]