SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569057 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569057 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682871,108195,7868,475142,645424,465022,300210,1027548,967305,217970,442003,430282,1032976,389542,267253,1000315,251959,610693,193410,526017,798679,588687,438122,403537,797354,823519,716817,348705,148322,479169,463575,178460,115875,647963,230738,2382,199247,702510,759664,130251,412706,458202,577728,151323,248096,1048876,38562,864336,392066,88076,798312,575687,1024617,842410,312248,497481,587568,431938,146774,56417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]