SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482301 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482301 [ RunTime:0.002559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294061,655904,311711,700118,182266,466913,468908,427286,1010670,731477,332888,90197,558567,338795,135543,219215,919659,530233,206100,498904,651104,296692,811799,565341,43870,950662,550467,6195,349096,575293,347932,801703,397958,579084,285542,573047,54064,369939,507409,497785,836322,926422,608684,308460,563029,768351,791501,612854,51744,157559,707839,636555,799556,449342,34388,263065,43913,92266,438468,129818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]