SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283911 LIMIT 1 [ RunTime:0.000577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283911 [ RunTime:0.002896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603816,457674,401872,186159,207476,605868,813612,812479,361604,27355,889040,969618,817348,536788,188051,286208,341625,467926,678018,817460,12354,920598,957543,779221,128812,307767,22938,653633,15347,324887,106684,401158,111356,707171,672463,1042602,282008,711326,650023,510989,338016,912635,1022789,1005147,516328,385167,964966,665937,66862,997335,1002683,665345,24244,825604,729460,831076,893233,893368,420001,235670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]