SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443992 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443992 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314506,120691,300091,38154,887069,483673,586924,644642,403401,703536,140867,493260,24784,1012275,991426,85472,26712,357568,906561,452047,552817,525568,1047379,485989,1026799,288948,463742,974353,524410,259546,778805,693512,469915,82873,224637,328463,994232,353440,915710,60638,360206,636630,385813,935103,969410,539365,248607,588623,997292,523428,557935,1007633,546207,1017366,761486,473033,1016411,348849,158402,665875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005860s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002407s ]