SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043528 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043528 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924789,839000,459477,914866,565530,620784,825842,476091,461672,880524,370034,804421,795601,567742,690005,194370,396084,629727,1018660,396577,241427,133994,683104,479159,536760,519335,818884,779944,1034867,784458,248783,186914,962711,192297,227777,44659,95958,891756,814377,460844,840089,1009586,737728,362848,491487,429184,223974,9384,172487,408493,379160,394508,494030,99326,205625,528680,989410,1045912,958519,122430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]