SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479810 LIMIT 1 [ RunTime:0.001061s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479810 [ RunTime:0.002457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280201,581748,676840,552579,864338,753658,232928,590479,828956,331924,26230,579819,847052,289402,642229,388386,645349,11449,793278,924660,877162,487157,714669,132892,528749,330897,177390,561109,485462,237218,913995,396018,279607,116060,621497,968814,462330,766289,575748,177953,507379,31777,93743,686760,27066,947213,969339,64336,212870,271636,192408,1031395,107626,328920,361909,157676,1039385,541599,111932,232657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001661s ]