SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408073 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408073 [ RunTime:0.001446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793425,909203,764017,43444,513633,851258,48545,140891,269137,598683,619020,998512,224921,960898,357549,339945,947462,826780,861799,212688,189396,48809,415112,1005957,578804,345940,547633,719236,360067,381737,870456,1022953,30768,580866,114946,905198,117979,1002858,859499,595499,850369,868121,384025,78123,25826,995850,243793,925198,722408,89763,773419,808019,7758,80733,88767,1027683,226881,412187,532907,44) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001800s ]