SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403745 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403745 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920931,918740,256364,629258,696525,284748,484661,225565,1002631,667510,788827,683411,544170,254042,633594,789746,144095,881384,455565,233485,724574,12147,75097,580649,57476,414746,414075,551583,490862,946732,83483,474602,644496,246290,534009,646711,690845,363768,1040701,488701,547115,483874,47767,691567,194271,811803,816420,554377,501242,930762,890514,255466,256701,525227,1032262,948117,861049,175822,642720,929486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403745 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403745 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]