SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001607s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580940 LIMIT 1 [ RunTime:0.000549s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580940 [ RunTime:0.004339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001106,312272,908068,414857,66400,406501,465301,1035407,212356,739784,818259,24918,489046,130532,112763,636642,660866,2336,944055,948423,300373,996274,971172,31877,580119,336804,930190,303456,1013488,78685,408296,861060,280445,761915,41770,440664,192795,177830,218756,98543,457103,339887,128551,504914,526054,37474,772366,358836,344199,596151,853168,543391,718587,965461,791104,1045665,319571,738210,561478,872283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000775s ]