SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540531 LIMIT 1 [ RunTime:0.000946s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540531 [ RunTime:0.010989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583960,537450,452772,708459,801590,564811,492183,606307,456751,564964,158987,184334,398446,308471,1037219,977232,133755,859943,432812,70150,39483,866793,746976,317618,145937,645545,862836,271214,382159,354164,188465,15974,164964,38139,497906,401194,917035,962170,156843,319763,327522,284800,26543,444482,753574,454535,901329,752471,717630,370548,669746,404155,477510,926872,227468,530364,515480,957334,643325,680456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001196s ]