SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470078 LIMIT 1 [ RunTime:0.001415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470078 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411530,737777,151260,144641,334,415434,746113,243809,369990,760300,862132,219544,414878,926591,504912,796063,755615,709318,923521,254926,787664,567348,1011934,534517,749051,440511,136007,706882,265233,723064,571486,673795,538803,517913,690632,728514,905623,176960,775140,267253,802414,990186,645042,92028,425807,759665,956519,328425,562356,46912,486367,781477,63568,431277,137809,953497,1014217,811492,928141,60794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]