SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451081 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451081 [ RunTime:0.002125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416444,716331,525261,423441,826160,275978,807585,786558,287755,726291,570375,131997,311481,46200,799238,737159,352562,214929,690736,818517,295059,995767,52814,404214,516961,547383,63473,405004,779555,362511,720135,766849,674672,42970,453940,832678,56735,199591,528539,823741,277419,1027947,549449,372143,763274,1023669,86506,456031,63691,940466,52164,347465,233590,914654,1000108,251305,627165,32199,692535,1038028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]