SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001926s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 694010 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 694010 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615438,45220,729370,185187,992142,930713,103517,856723,322069,138751,790131,578344,680447,783902,671950,71179,224582,452100,385505,949475,599865,1013408,997524,231362,501413,607631,703308,713861,191058,872356,1021958,608466,844124,648324,795191,595164,991938,53363,625247,124068,12089,2191,1005716,797401,382592,666786,296190,492180,353491,648524,365523,851534,237336,134674,772396,331913,792479,178509,608694,232771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 694010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 694010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002222s ]