SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 945853 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 945853 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029125,1002980,40382,379734,646100,137947,952284,534316,973376,172618,281937,1000625,660667,53597,997470,906224,945713,826221,137490,290815,987811,593017,145568,218648,244438,169947,255149,370306,261598,497633,1001482,240627,34411,888875,707809,73486,219259,695722,445561,664857,75488,481167,888162,436036,748399,910255,883064,341868,223260,24023,64879,696233,384960,865788,363679,704265,991743,797750,1031339,480410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 945853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 945853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]