SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45434 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45434 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167010,914614,912876,881154,412527,821947,537848,457492,805944,946142,613431,398057,263544,741922,967948,675477,330653,115283,284376,2910,430099,676398,177390,1001326,687991,771012,450713,640211,620968,464581,447405,115966,106916,374130,416163,813990,745841,434134,120340,904752,504954,353642,130772,168140,433299,194573,589376,551004,957857,1001560,146439,796827,854690,817962,91012,315838,990070,750583,516428,407536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]