SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010095 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010095 [ RunTime:0.004017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576889,543850,87092,94378,155653,124762,435759,748636,998860,927154,132731,175743,489595,458792,127514,518525,103136,738202,510203,99779,214215,623034,339620,828979,94123,55532,540756,193246,660171,186865,100509,163496,749747,677304,472882,539461,914987,343167,293212,936704,602035,496932,513447,1039758,176468,285832,562666,892246,552293,484392,970425,635719,139921,220892,618452,221701,383250,958868,722022,118584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004297s ]