SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027334 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027334 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690849,1043976,480277,1017594,578407,61953,421378,717171,656295,191246,549151,190643,623326,625255,520556,813938,392301,194127,62097,321412,375923,249914,546102,17046,688560,794039,283989,594201,808749,580113,699391,589531,11891,771370,998898,160525,935043,822835,163567,182420,1046338,198839,840190,506796,303923,881391,429692,264398,112034,13840,244993,464431,542708,652759,938098,617355,49836,945446,626241,345291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027334 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027334 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]