SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002723s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422638 LIMIT 1 [ RunTime:0.002100s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422638 [ RunTime:0.003082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814087,356485,368706,111249,27775,1032282,605057,3657,686688,269690,118848,794691,24685,248999,24883,396842,771128,423722,910163,737488,146140,96521,353673,139742,463891,655573,672694,753737,265286,770477,708221,311816,769234,141990,179584,1046064,744211,95543,177675,812150,360838,522532,672769,354072,702895,227629,86484,125939,145589,104579,210229,483095,642650,669535,1002567,371411,524921,650329,920834,269235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003980s ]