SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003991s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485418 LIMIT 1 [ RunTime:0.003725s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485418 [ RunTime:0.002576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753634,97140,90943,313471,354714,355093,988058,484298,77036,364571,925902,856082,992585,425498,521405,291948,272513,500806,581673,272774,657987,932419,57486,499802,22513,588903,909100,308519,421184,613519,457201,595702,261140,157908,707125,502485,490674,588649,866828,524002,15954,643887,267825,371792,980959,358160,672234,592187,331551,1044286,443492,899455,255398,768820,410689,91202,389443,731809,769439,1028602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]