SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515004 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515004 [ RunTime:0.002597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930102,379086,155681,376625,995374,124599,550183,447809,503666,272349,773963,661848,32428,773141,583337,887412,100863,443594,588194,143671,340361,490954,965647,576704,829848,57880,105202,582332,940226,854038,658611,499432,973002,732218,550472,547246,689630,14882,628858,121364,533534,20744,339867,114295,649484,745053,885428,1035202,629572,851605,234763,158751,817372,346678,557258,582128,158286,527978,258682,403953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]