SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001833s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022890 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022890 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44839,589972,1013288,451166,474286,786892,868411,345184,626124,629429,948257,722134,862186,1022209,338693,764280,85815,659999,44711,466244,694098,251263,133104,412180,762723,411531,127785,615658,656861,358700,974836,576675,448665,1012596,983943,842377,450279,174080,829441,362620,421694,196253,496560,728983,889256,39765,31482,367066,986122,862441,266103,6678,426023,298555,87053,546260,931030,1048880,997017,420243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]