SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428442 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428442 [ RunTime:0.002276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31297,997016,318503,888001,143361,126460,621113,935970,167137,278712,418057,449392,1036499,370435,1047227,1043528,818016,156501,117164,1048012,334063,623504,993522,799726,1024702,483692,233310,725968,176562,766888,55066,658907,998681,609115,467184,116572,844072,142355,1016692,770275,510979,232453,15505,460404,652627,948521,270470,981394,510455,922072,495726,4662,973643,965298,200952,84732,848459,641855,923259,226648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002008s ]