SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142004 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142004 [ RunTime:0.004227s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435747,865315,788256,866265,907307,499093,589387,79362,916463,106054,112508,41618,968095,906474,271097,787618,873378,388902,833116,839365,1020537,454170,629739,130668,250151,156366,357168,462291,229113,1042611,175861,613093,84266,823388,412283,584387,106872,458103,687918,1015407,506473,716709,809340,50812,556249,252532,402310,124395,22634,424421,573209,265375,393489,579307,804976,657216,440394,521359,369914,225776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003456s ]