SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002885s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 816143 LIMIT 1 [ RunTime:0.002186s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 816143 [ RunTime:0.004815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048669,402003,595248,417648,279243,970012,749149,214172,886512,414789,484861,642632,908741,916558,929862,374115,131574,813850,912661,503038,163429,1016048,764253,916093,157563,533330,298807,466919,42264,295183,435416,304798,406509,443387,815540,314535,194495,429123,358022,85973,45550,797681,397997,775546,270819,697578,722621,38451,33355,156762,905722,22942,176283,550016,977212,473713,641297,456945,303339,935277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 816143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000828s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 816143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]