SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10458 LIMIT 1 [ RunTime:0.001096s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10458 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800631,184883,810829,331810,61215,654443,502101,743630,350574,842235,1029084,578797,89313,566680,497175,131740,611017,559467,826029,592712,674825,141382,163643,297552,24464,292519,1043820,594711,292665,692978,299277,92056,522101,795457,813865,375470,935376,725591,332577,489390,413945,422093,633551,778604,1022292,118500,779401,269158,180365,510561,573551,261885,572576,972735,571283,9057,270750,809639,851860,960033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]