SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020201 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020201 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199978,836084,306879,169356,382525,657531,480324,1034188,379496,41200,269687,666196,65713,747502,536761,884151,936052,573950,748443,948518,606366,1010865,77993,720508,346999,963611,90027,90749,44302,640524,1043579,747774,622786,514129,631909,347002,993404,590892,779551,20749,971546,309289,1011683,89610,978258,196134,986078,20478,685610,571564,593811,817985,225480,282419,258767,747525,996225,360032,958108,29898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]