SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 760311 LIMIT 1 [ RunTime:0.001011s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 760311 [ RunTime:0.006172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770804,383215,967031,536751,411206,839348,869009,292430,715867,585732,1004748,197751,447703,296610,67472,366282,371900,384438,385110,921439,619477,676248,419666,821632,961195,209138,840338,524752,894073,89177,135377,558513,912155,443690,470274,54806,145866,513040,773701,139855,624720,41291,1034749,157248,497684,302645,730549,103430,16887,539235,1042689,251191,391721,26002,522142,132414,158457,520144,530531,837912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 760311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 760311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]