SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506474 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506474 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918420,277990,372175,678724,133368,222140,950678,930779,47840,674891,134996,902955,32227,670032,664465,299745,530068,651136,32957,1550,565001,379167,1024198,163500,444580,355005,420173,899237,174002,958995,372028,956953,672264,301312,504360,512948,25917,658102,64678,648128,300696,959754,249602,97643,973842,555957,579599,407820,151757,45220,886844,505541,278363,37695,286006,852801,82744,615006,726211,962582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002334s ]