SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019651 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019651 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520675,790814,340895,65636,539129,376100,163595,836917,653529,937919,735854,236681,386330,371094,686387,166289,735248,218570,718884,526701,273254,1014267,1025734,18851,168284,993185,534290,118034,882890,462815,1034751,458333,579431,1003629,751862,342710,209600,214145,995354,525114,712094,427468,472164,617303,761664,1000669,1000503,812600,689468,461423,302332,897003,903365,314768,492604,309416,917531,753766,649117,735432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]