SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014964 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014964 [ RunTime:0.001927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874199,877432,71591,969010,825813,76595,419908,109736,359961,232307,56955,76292,298197,696066,557262,261313,85498,810225,449602,654649,778208,630625,179818,359515,772829,886592,996056,494815,635901,754517,411003,292251,361788,477211,196956,938471,359749,2425,752161,97695,871195,185558,479570,912891,201238,205798,391179,383815,698431,751277,734930,311870,451783,247866,267670,780642,567418,863866,165180,870474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]