SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591713 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591713 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514180,418299,586360,515669,823788,683861,319309,810614,486897,967545,84006,301619,68183,933512,562398,120997,330924,228492,170736,345327,383752,6392,483604,713539,383001,913017,140251,321448,1040210,984457,128697,322449,195192,90723,500584,605918,266286,411892,597042,851656,968681,722453,813563,418335,208996,863387,797317,309974,740491,548549,77506,885385,835988,124983,602888,871635,862763,426028,536227,236020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001053s ]