SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427380 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427380 [ RunTime:0.002205s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215358,198840,508761,606922,16501,129226,215558,127988,879055,921706,398512,193180,375693,121302,580979,758264,412503,84939,734324,200545,919599,242426,236888,1005257,893371,1020498,725954,393058,596706,686128,617716,1583,484884,990572,370657,257735,603539,948657,530062,186075,752335,285121,391380,453004,913943,398405,967931,909028,859315,750913,1016354,808522,1005048,185216,747088,859423,257657,812387,884698,946095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]