SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477273 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477273 [ RunTime:0.004717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301267,378996,431940,1015380,246860,1000308,552628,154489,474000,788715,542313,700050,883627,207415,363464,180798,965380,341104,405116,394524,985460,74662,108457,828523,876821,483300,974349,425624,117402,687950,586645,612748,185765,551254,175285,703843,718235,240112,186346,762575,379744,459367,75994,897925,855683,6329,456182,794994,688100,245223,42834,210198,506008,475056,787003,210597,915289,769112,481920,981783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]