SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017772 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017772 [ RunTime:0.003594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43924,681230,993563,320437,564131,129358,164083,390635,573720,862109,231763,759917,588814,31848,903898,450327,952262,561990,698474,761206,155421,428759,446682,461729,970596,937872,612838,180300,186709,924777,70534,630696,543001,437422,825979,851680,716272,189611,808720,209349,367787,992033,285201,105715,942987,231663,297452,1000515,193923,878962,188825,203333,747404,136437,286933,344775,542759,586134,37376,479173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001798s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017772 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017772 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001886s ]