SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195435 LIMIT 1 [ RunTime:0.000554s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195435 [ RunTime:0.002277s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775917,275746,344196,257469,526393,544720,571727,180712,335403,539794,1031218,522853,958403,436450,911963,1021136,604008,562642,493931,689296,483335,396963,989040,532313,531271,803598,245621,824144,1030372,545927,993554,136717,379393,807226,641104,75174,109128,254024,631885,795354,899099,128511,327381,773477,507818,60384,362090,439745,55291,52163,470320,842769,166979,508102,125152,819328,951648,720146,397001,397420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001888s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002972s ]