SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004801s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292567 LIMIT 1 [ RunTime:0.001756s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292567 [ RunTime:0.004660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766086,352390,436487,465507,1021099,131204,300958,438718,140575,673045,25948,531641,638404,1016910,526441,588036,460449,852866,473111,334790,81296,310604,927094,198831,1010088,78774,126051,843331,597755,41183,670181,374583,362365,371180,910457,871815,1043546,356594,440010,436581,132819,363279,764890,649277,846595,587236,448391,651103,420319,549625,192289,906805,135808,828863,380769,909197,935240,946025,148818,976100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292567 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292567 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]