SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 703428 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 703428 [ RunTime:0.001474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8567,380475,477883,490093,137502,730941,449195,446985,808205,787732,693695,276329,685976,977653,656499,461389,653596,462201,550813,150108,99748,290184,26329,165955,987648,229092,903603,168243,768916,107377,643478,690219,707613,552251,498723,520986,884330,9541,494512,839046,281570,289167,1037588,733403,245438,489329,480744,919346,832669,404801,143586,404050,656416,204676,965645,70650,90892,825136,269267,993821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 703428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 703428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]