SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536238 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536238 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435703,655331,609239,343758,98862,359481,187990,982894,360647,156034,548462,100855,988632,500146,937109,499356,741836,7879,690213,626867,219559,939101,47433,959000,243706,879810,585442,717230,607280,629340,657849,51674,1045962,798763,694675,15726,967674,1021123,646726,144663,582243,235804,1013661,526589,221415,494677,595980,954254,188654,508393,673136,456744,455424,404936,495049,974043,836478,278114,674337,154931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]