SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426102 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426102 [ RunTime:0.002551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513982,778471,922581,929504,535907,39617,719202,400002,788853,1014383,303192,233421,615893,776147,945932,998117,264559,701401,493203,798129,777577,1004308,1011,178819,295185,941441,126359,954343,982899,706279,747694,985466,821184,837777,980789,483734,632308,342196,313114,1009639,582052,131851,240821,39673,249206,107113,815908,906232,1043845,80234,426482,789186,522522,495740,112362,139158,613818,873779,177211,949827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]