SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533989 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533989 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200743,960437,604787,566588,44517,794855,104540,178543,344861,327279,200656,751767,602155,115847,791103,149456,117108,226963,479480,228294,75121,7178,830919,964622,272593,646723,1044975,655342,566267,711594,1001803,193767,830834,768702,728691,783470,139988,581172,657100,999194,949160,474707,692693,850001,488932,645668,977040,341766,603742,715880,1041087,228568,61270,824915,1013913,358550,119215,811697,67480,715615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]