SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529876 LIMIT 1 [ RunTime:0.001913s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529876 [ RunTime:0.002383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851754,332584,766458,181723,879818,18247,447888,987623,944299,634188,295699,526949,465589,601098,409775,463729,101260,181548,32251,548169,754987,519484,486760,427674,258028,102880,652344,868557,642994,278088,771344,852345,40334,643370,897335,191979,592388,688207,419026,683116,110459,431051,743159,955384,57648,632760,1004889,778235,751870,999447,557423,780281,265562,37551,572193,747451,996190,837022,765742,285048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]