SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017508 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017508 [ RunTime:0.002382s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836873,518246,127887,932721,179075,1012415,583926,187663,751053,1009020,552278,121064,947227,665479,324792,106100,62608,335956,368661,463836,319184,81817,899021,402056,824896,256932,391224,488285,168988,98744,267080,298019,107739,307114,301405,686906,430784,411607,979682,136574,774655,883815,226563,202908,484524,344724,170271,514059,723186,356173,331761,241178,304283,934509,1038658,82088,113691,51901,950229,62210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]