SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001893s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568267 LIMIT 1 [ RunTime:0.001512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568267 [ RunTime:0.002311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556156,167943,551197,392961,841608,74800,761598,636561,933020,1012807,774163,248936,817035,400395,422118,824422,976461,662272,365215,600939,190350,810204,374680,261385,456578,939727,385630,286156,434577,601915,912619,625785,32507,277176,359187,525306,622029,618356,665136,755663,1002210,1002812,763840,790640,302983,152387,20192,124288,224403,914721,729914,596279,941598,54454,690430,297583,764099,699567,125842,218615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568267 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568267 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]