SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001903s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285081 LIMIT 1 [ RunTime:0.001379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285081 [ RunTime:0.002364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354506,1032560,983213,454850,205138,994176,558751,570350,497616,17849,531379,110357,426435,33917,132990,103844,722781,20635,285169,14150,8922,58621,547496,613468,427119,171529,375823,293607,574007,690636,516487,127668,544587,1027721,58795,876818,496553,989789,932326,42262,343214,206734,583563,1026836,628162,419322,678632,245295,826825,589476,175234,832659,165221,1044004,141394,336381,997734,502562,816478,479949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]