SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415691 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415691 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445408,870633,426805,35271,835034,76300,639358,635050,453145,332326,210526,128657,20100,292414,311244,176345,123769,228879,502123,820196,574400,1036019,1041189,173356,991631,1031769,981960,609248,393942,482157,451136,630073,747259,770484,58087,39794,360108,5660,1038663,590407,1027374,511567,751332,53052,816112,975055,707679,430471,1019416,157711,610824,240434,684037,398839,520160,960185,802743,960299,658127,589676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]