SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399012 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399012 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514013,470604,490070,55167,10507,998002,7092,62092,586421,3323,504558,111371,1040303,927107,880565,219423,145637,146328,124332,135489,785082,286124,899099,264256,244817,161062,452671,338895,478774,850686,771912,441389,627458,547157,1026454,259680,38358,617968,762070,765349,715716,510868,1032223,171522,409597,265159,159122,198394,74799,230332,639138,788674,787950,517999,862186,844101,30570,273868,96747,288996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]