SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046273 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046273 [ RunTime:0.003185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690078,8240,504370,729900,277641,159941,662674,1038291,729026,766390,52943,854571,41062,389194,266153,258345,339537,362137,541718,85358,498291,545877,47147,767826,140568,350022,720725,254642,221948,476464,821340,666689,367507,99434,481542,858229,740866,434954,575770,388240,119774,203626,225668,126845,341097,324603,276194,662413,690596,790970,830300,642182,896535,32622,583165,436693,981712,579707,418358,1006688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]