SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45126 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45126 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566214,127171,939975,136375,993581,152814,942133,569478,519224,243807,1896,688148,605241,473904,175480,551841,675227,553320,499513,436085,919355,701980,296754,154924,449861,565588,399429,555620,958827,790879,270257,1027710,869087,192753,271632,431868,481069,761739,28274,377923,932399,208523,700187,452096,107671,774980,79823,966562,496504,707673,694578,581596,972221,600058,450592,227485,552093,42266,856071,170911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]