SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583404 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583404 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014152,812435,1008585,297571,778018,411798,516889,476626,434584,614226,510694,126478,307125,65866,355403,721546,1041749,448055,989094,821884,476351,587979,874583,885822,974517,722368,1041093,20800,239293,829286,209180,1034076,196352,71439,719755,469831,521155,553305,960211,304722,58361,734029,404882,724331,826579,289284,901448,914829,682956,79692,185396,69715,276233,980587,513856,987654,1013760,9302,59144,732062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001830s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]