SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200528 LIMIT 1 [ RunTime:0.000920s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200528 [ RunTime:0.006780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486440,461631,320104,343426,105837,752603,608072,261144,614029,466385,15803,646623,730154,474420,466796,45455,336359,964485,457597,232364,857317,364357,599834,725213,828941,346842,1030086,967052,487442,897159,478005,84732,138427,975516,434441,645750,750757,406932,159082,338360,407363,589940,774331,402850,393947,629173,494998,471609,822046,550875,113903,872791,350530,902299,78053,711517,265041,1018740,151667,113598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]