SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404550 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404550 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435152,222897,156558,958453,122975,257498,428842,443190,395129,392359,990488,398087,637767,38734,860577,729595,595616,80761,670905,553395,53133,308741,895301,831318,497520,475326,847686,700307,810888,613577,896734,378152,340415,737497,769669,330109,886710,67928,263246,109844,1032049,346561,877354,559743,546919,435064,1015653,371534,464261,183548,719173,572240,168100,981528,641168,748119,330442,370483,258219,872824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]