SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39190 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39190 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380493,813222,49250,375145,595561,55376,120420,780389,613121,139799,276923,428942,677222,11265,1020218,681390,1037501,950964,396590,706833,99179,598333,956334,703673,616611,818429,417231,1027942,508580,14615,281845,104800,35925,991146,234242,38209,2609,474851,19407,403863,224720,660823,404961,300952,22512,583383,904968,174753,884885,410501,591539,68474,197796,984218,278208,445315,706590,139599,336407,220003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]