SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804545 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804545 [ RunTime:0.003097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274850,459618,151525,25621,195182,1005960,356190,461746,992881,968175,36382,563591,863253,513180,675755,193881,872535,35261,141008,384450,475894,4736,271371,753845,917098,722597,556371,488739,58185,128894,35942,27967,381686,1001264,450775,500788,1024762,222271,582779,717592,978985,933787,377174,37096,320496,586139,741961,901789,389029,885727,412752,585160,865722,637680,993535,94484,544684,781672,689194,850037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.034950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002751s ]