SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106312 LIMIT 1 [ RunTime:0.000672s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106312 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413026,515198,827662,327524,1018217,401649,781319,201984,803328,692759,408639,129828,136683,492997,50417,6734,462158,135276,146062,869800,620110,726519,663059,551895,618950,312493,787833,416978,878294,8717,168465,1031051,389853,72561,986676,216398,627252,891243,28840,1037182,953333,939244,301936,582907,1031074,473114,363669,11203,413459,38407,67126,921825,511777,464310,304808,857914,661708,961989,802042,33333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]