SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022057 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022057 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496629,390984,452537,631528,205691,942642,308350,759147,775078,223017,793880,654331,470161,952289,910197,980185,423275,674250,147481,362947,768583,478915,533490,437749,1047941,495296,387609,409223,1038140,934839,567251,1025823,278428,169723,435418,159043,212492,1013504,14774,346399,972776,821506,111817,110065,184212,231732,521479,797804,392848,31508,40013,82446,488697,270240,748180,645093,660941,183704,858106,298729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]