SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002840s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351117 LIMIT 1 [ RunTime:0.000514s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351117 [ RunTime:0.003972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917488,823144,785883,344874,552475,1031913,728138,682163,516277,193934,788450,88032,15051,651998,721676,236578,481174,468241,471561,990762,262787,144264,604713,384349,833695,384747,879348,445764,881549,236089,1031504,495854,388130,603184,228146,485507,651641,116635,92590,294000,448386,194062,913583,198398,127308,468779,355310,281793,104093,815835,943515,787764,126995,341769,149123,991012,1045625,587835,975428,394400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]