SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5389 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5389 [ RunTime:0.002476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436676,465640,33104,210017,206787,1044356,435673,224919,124411,670343,743205,180580,563901,378399,295576,27866,661946,399668,986312,607125,792337,381093,722112,964657,289755,165295,887067,147162,1002879,1000083,872562,1035575,262689,306451,192500,440639,519267,158742,1015587,231354,725461,166071,778500,867146,1044999,741195,801001,214741,332317,478513,995951,820107,152742,734472,694878,226441,609050,341080,523829,529525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]