SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003899s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394575 LIMIT 1 [ RunTime:0.002303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394575 [ RunTime:0.005162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014634,778199,711265,263344,77881,329800,781882,805509,429212,879842,224799,339259,221836,235496,1003849,336862,1036499,1036984,932528,483221,272696,69337,871056,848326,1020043,142216,206138,94229,572475,620213,801408,587102,191337,961553,488797,855138,66907,424909,61262,695847,757815,194516,1017673,546484,316592,848782,431683,272873,282538,174562,1024083,92569,867137,702918,165493,758573,121582,94455,711189,954879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]