SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971617 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971617 [ RunTime:0.004305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806930,359007,602784,672453,1023248,637994,551218,597545,439257,243594,422601,176588,526574,472978,816048,798206,439289,305092,576688,772379,795910,1000209,520324,478015,301151,537336,668114,170375,315198,1021629,81490,958861,455432,1022042,348418,440581,578572,760342,746200,208393,629800,675433,415476,147837,775686,977553,570445,429026,21072,1012007,610348,376121,791253,213058,570686,338680,913595,562184,989817,1039992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]