SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492517 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492517 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005048,901247,261701,852802,547911,885801,184692,974350,98229,109581,213702,379685,95766,579174,731440,756843,410340,156231,892589,702540,938951,371615,459365,934681,863612,338646,703367,203245,593783,596260,12693,441045,803898,531977,296314,336688,931788,19402,65006,462735,757180,561188,230003,447173,814018,468435,1004478,241588,57548,45396,775210,591932,195354,691447,80122,218086,398,377763,567888,666426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]