SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001451s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470614 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470614 [ RunTime:0.004716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439279,532732,728243,366376,522152,301652,499119,1020816,177430,698851,639568,638221,923202,490875,237059,354448,493479,437393,796645,725429,136155,149341,844381,481881,661155,638110,497945,23040,801194,382018,1025893,491292,77132,811051,496340,763708,904370,756009,1044517,298394,433951,809536,106182,1026759,928731,828891,514002,814443,983608,446989,244913,538087,870888,528422,553178,130770,546645,823805,1021860,759041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003487s ]