SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468682 LIMIT 1 [ RunTime:0.000647s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468682 [ RunTime:0.002404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835372,215551,164151,708079,1000422,590160,341181,59688,387023,775380,687091,166455,547958,695633,730578,526855,32211,461483,945407,834670,12803,453919,144847,147211,30250,157790,331804,40070,108174,832520,944604,929146,1048897,975850,785098,863864,1003004,453339,429995,150171,787809,484991,201315,323241,330538,441806,433113,869734,237376,84250,97386,96340,239135,837791,511291,460241,65054,402305,746790,605022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]