SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001773s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391563 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391563 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026227,1002538,879781,122739,478326,350898,375408,453409,841215,612392,47280,835241,457517,492422,249524,521664,545225,372180,668877,25520,848128,310548,533828,964608,234684,94613,934806,496840,695421,735930,180916,536208,809134,278064,104939,104196,957836,541628,940634,938600,498103,224062,160397,619987,323463,800105,242835,290175,62610,906151,503154,1013623,527658,115060,32525,879110,728695,18990,994969,694723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]