SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545319 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545319 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201023,919001,421405,93779,373695,49376,978513,476647,419899,784458,270355,370570,284143,442544,275024,888327,741048,784351,50987,806613,13898,703599,477075,728237,377655,445958,714982,9795,134272,835109,467962,347710,800454,27317,206331,837233,621928,784182,218909,550682,450323,502587,431396,382005,883530,988617,316329,225722,871956,619602,161593,378569,74785,809182,298409,875646,791476,95690,473358,882024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001343s ]