SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416938 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416938 [ RunTime:0.004649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408484,972084,192561,222747,695263,896344,569934,599482,102742,831842,471608,1034414,239018,28374,681458,566730,101692,254388,888608,721153,965138,966634,506714,434963,229841,125171,149507,848021,402085,268904,905002,997333,300589,741736,586839,425059,506610,640653,995459,333879,675383,232238,1015489,447848,153398,827709,773641,478947,638261,1026867,417254,195165,996352,326888,968274,657099,501591,121051,394290,768671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]