SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013157 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013157 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207929,403943,386641,838687,996829,993659,457907,940057,833169,481158,40498,325997,363910,644540,236757,819254,894056,356915,203728,546435,642438,119660,499371,1028809,990148,232259,235042,796525,741457,257895,402535,880418,751507,985002,793043,356449,494473,685952,427345,884979,611139,634523,885565,264476,650493,883482,185609,934308,391214,784972,738318,134791,433164,1032362,735517,265529,705814,113822,323317,685206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002603s ]